Benchmarking financial database queries on a parallel machine
نویسندگان
چکیده
A database benchmark exercise on a parallel machine for a large UK bank is discussed. The benchmark involved eight queries running on a subset of the bank’s database across 10 processors. All queries were of the MIS variety, and included “real” marketing queries. Some queries give speedup of over 5 times on 10 processors. As a result of the data distribution most queries showed speedup up to 5 processors but then no more speedup until 10 processors were used. Tests suggest that the limit to I/O throughput lies in the disk controllers. The effectiveness of query optimisation and decomposition are also discussed.
منابع مشابه
Benchmarking Database Systems A Systematic Approach
This paper describes a customized database and a comprehensive set of queries that can be used for systematic benchmarking of relational database systems. Designing this database and a set of carefully tuned benchmarks represents a first attempt in developing a scientific methodology for performance evaluation of database management systems. We have used this database to perform a comparative e...
متن کاملDeveloping a parallel benchmarking suite for Java Grande applications
A Grande application is one which requires large amounts of processing, I/O, network bandwidth, or memory. Grande applications include computational science and engineering codes, as well as large scale database applications, business and financial models. Increasing interest is being shown in the use of Java for Grande applications. The purpose of developing a parallel benchmarking suite is to...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملBencbmarking Database Systems a Systematic Approach
This paper describes a customized database and a comprehensive set of queries that can be used for systematic benchmarking of relational database systems. Designing this database and a set of carefully tuned benchmarks represents a first attempt in developing a scientific methodology for performance evaluation of database management systems. We have used this database to perform a comparative e...
متن کامل